﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'ConstraintKeys_SelectBy_Constraint')
	BEGIN
		DROP  Procedure  ConstraintKeys_SelectBy_Constraint
	END

GO

CREATE Procedure ConstraintKeys_SelectBy_Constraint
	(
		@ConstraintId uniqueidentifier
	)
AS
begin
select CONS_KEY_ID,CONS_ID,CONS_KEY_PRIMARY,CONS_KEY_FOREIGN
from CONSTRAINT_KEYS
where CONS_ID=@ConstraintId
end

